Datset

The dataset has been retreived from Kaggle

The data contains sales of six months of the year 2023

Store Location Analysis

Conclusion:

  • From this analysis, we can say that all stores’ sales are good where sales of store at Lower Manhattan is higher compared to other locations with 71742 sales

Product Category Analysis

Conclusion:

  • There are highest sales for Coffee with total 89250 sales followed by Tea with 69737 sales

Product Type Analysis

Conclusion:

  • The highest selling product was Brewed Chai Tea with 26250 sales.
  • The second highest selling product was Gourmet Brewed Coffee with 25973 sales.

Product Quantity Analysis

Conclusion

  • There are highest sales for Regular size with total sales of 70186.
  • The second highest sales are for Large size with total sales of 68540.
  • NOTE: Not Defined refers to some products where the item size is fixed such as pastry, etc.

Profit Analysis - I

Conclusion

  • There is highest profit gained for Barista Espresso with total sum of 91406.2 .
  • The second highest profit was gained with Brewed Black Tea with total sum of 77081.95 .
  • The least profit was gained by Green Beans with total sum of 1340 .

Profit Analysis - II

Conclusion

  • The highest profit was earned on Coffee category of total sum 269952.45 .
  • The second highest profit was earned on Tea category of total sum 196405.95 .
  • The least profit was earned on Packaged Chocolate category of total sum 4407.64 .

Temporal Analysis - I

Conclusion:

  • The overall sales are higher in the month of June with 50942 sales followed by the month of May with 48233 sales
  • The data contains sales of six months of the year 2023
  • The least sales were happened in the month of February with 23556 sales followed by the month of January with 24870 sales

Temporal Analysis - II

Conclusion:

  • The sales on Monday and Friday are comparitively high with 31231 and 31207 sales respectively.
  • There is huge dip in sales on Saturday from Friday with 29614 and the sales on Saturday were very less than all other days.
  • There are average sales on Tuesday and Wednesday with 30449 and 30625 sales respectively.

Temporal Analysis - III

Conclusion

  • Sales were recorded only between 6th and 20th hour.
  • Sales were highest on 10th hour with a total of 26713 sales followed by 9th and 8th hour with 25370 and 25197 sales respectively.
  • Least sales were happened on 20th hour with a total of 880 sales followed by the 6th hour with 6865 sales.